package com.webside.Advertisingstatistics.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import com.webside.Advertisingstatistics.model.AdProvinceStatEntity;
import com.webside.base.basemapper.BaseMapper;
import com.webside.resource.model.ResourceEntity;

/***
 * lpz 广告投放区域统计
 * 
 * @author Administrator
 *
 */
@Repository
public interface AdProvinceStatMapper extends BaseMapper<ResourceEntity, Long> {

	// 在每日00:01分的时候将昨日的广告投放区域数据 统计出来并存入mysql中
	public int addadProvinceStat(AdProvinceStatEntity adProvinceStat);

	// 每日00:01分存数据时先删除原数据
	public int deleteAdProvinceStat();
	
	//根据广告标题分组查询该广告下面所有省份的点击量
	public List<AdProvinceStatEntity> adProvinceStatCkList(@Param("adTitle") String adTitle);
}
